SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Procedure [dbo].[TvShow_Get_Seasons]
@ShowName VARCHAR(250), @SeasonNumber INT, @User VARCHAR(250)
AS
Insert into TvShow_Season
	(
		TvId, Season, IsWatched, CreatedBy, CreatedDate	
	 )
	 
	 Select Id,  
	 @SeasonNumber,
	 0,
	 @User,
	 GetDate()
	 From Tv Where Title = @ShowName
GO
